DWM and Excel

Author: Steve | Created: 2010-02-10 13:21 | Last Activity: 2010-02-10 23:36

Original Post

2010-02-10 13:21
Can someone explain to me how they set-up EXCEL for their DWM lists? I gather that several people are using EXCEL for DWM and finding it works well.

Reply by vegheadjones

2010-02-10 14:10
I am very happy with my excel set up. You really only need two columns, "expiry date" and "task." And then you can sort by expiry date.

I use macros that put in two types of dates, today+30 and today +7 and have them copy and paste special so they do not update. I added other columns including days left (=Expiry-today) columns, columns for time started and ended and a link column to link to needed urls and files.

In order to get the flipping through effect, I filter by days left to see only tasks that expire today, tomorrow, et. al

Hope this is useful, I find DWM excellent on Excel.

Reply by carlogs

2010-02-10 15:02
I'm preparing a DWM sample implemented on googledocs. Stay tuned. I'll let you know in this post.

Reply by Steve

2010-02-10 18:00
Sounds great. Looking forward to seeing it.

Reply by Man of Kent

2010-02-10 20:09
See http://www.markforster.net/forum/post/1009995 for my implementation in excel.

Reply by Lillian

2010-02-10 23:36
Mine's a simple 4-column setup - Column A has today's date, column B has either N (new) or C (continue), Column C is a formula for the 'expire date' - if column B is N, then do today+30, if it's C, do today+7, and Column D has the task description.

I also put in conditional formatting to change column D to purple if expire date = today. I haven't had anything turn purple yet :)